Knowledge Sharing
Döcu Content
Read Lotus Notes Data via URL in JDeveloper
Xpages/JSF Application
Introduction:
Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server
Current Lotus Notes JavaAgent, code running the actual TXT file shown in the URL
Site URL
http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
/**
* Created from copy: 2015.07.04.12.39.PM
* HTTPDDECSVDataJDevJavaAgent
* CSV data for Xpages to be read by Oracle JDeveloper Apps
*/
load imports
import lotus.domino.*;
import lotus.domino.local.Database;
import java.io.PrintWriter;
/**
* @author Dököll Solutions, Inc.
* @version 2015.07.04.12.39.PM
*
*/
begin class
public class JavaAgent extends AgentBase {
open method, this actually runs the whole App
public void NotesMain() {
let's add a try catch here, to grab errors near the end
try {
open our session...
Session session = getSession();
load info to console for debugging purposes
System.out
.println("HTTPDDECSVDataJDevJavaAgent System User, We've got a session..."
+ session);
load agentContext
AgentContext agentContext = session.getAgentContext();
...
System.out.println("got HTTPDDECSVDataJDevJavaAgent agentContext..."
+ agentContext);
find database based on session found
Database database = (Database) agentContext.getCurrentDatabase();
Find view in question according to current database
View view = database.getView("IssuesListings");
System.out.println("View Obtained..." + view);
declare document variables
Document currDoc;
Document tempDoc;
grab first doc
currDoc = view.getFirstDocument();
PrintWriter...
PrintWriter pw = getAgentOutput();
System.out
.println("URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt");
Content type set at Txt
TODO: Figure out a better version to load a CSV file to browser
currently, the csv downloads to local directory
pw.println("Content-type:text/txt");
while (currDoc != null) {
write records from view into a Text file and show it in the
browser
pw.println(currDoc.getItemValueString("UserID") + " "
+ currDoc.getItemValueString("PageID") + " "
+ currDoc.getItemValueString("priority") + " "
+ currDoc.getItemValueString("issues"));
Get next document
tempDoc = view.getNextDocument(currDoc);
recycle currDoc
currDoc.recycle();
set currDoc to tempDoc
currDoc = tempDoc;
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
JDeveloper Test Log
Second attempt to connect JDeveloper with Lotus Notes
*** Using HTTP port 7101 ***
*** Using SSL port 7102 ***
C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\DefaultDomain\bin\startWebLogic.cmd
[Starting IntegratedWebLogicServer.]
[waiting for the server to complete its initialization...]
.
.
JAVA Memory arguments: -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m
.
CLASSPATH=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\features\com.oracle.db.jdbc7-dms.jar;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\lib\tools.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic_sp.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\net.sf.antcontrib_1.1.0.0_1-0b3\lib\ant-contrib.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\modules\features\oracle.wls.common.nodemanager_2.0.0.0.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\internal\features\jrf_wlsFmw_oracle.jrf.wls.classpath_12.1.3.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\com.oracle.cie.config-wls-online_8.1.0.0.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbynet.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbyclient.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derby.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\xqrl.jar;C:\PROGRA~2\OPENOF~1.ORG\Basis\program;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JCOMMO~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JFREEC~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-25~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-35~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\csvjdbc.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JASPER~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\iReport.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~3.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\ITEXT-~1.JAR;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc4.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\DB2JCC~1.JAR;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\java\Common.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.PRO;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\CO49EF~1.JAR
.
PATH=;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\bin;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\org.apache.ant_1.9.2\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin;C:\app\ADMINI~1\product\112~1.0\dbhome_4\BIN;C:\PROGRA~1\COMMON~1\MICROS~1\WINDOW~1;C:\PROGRA~2\COMMON~1\MICROS~1\WINDOW~1;C:\Windows\System32;C:\Windows;C:\Windows\System32\wbem;C:\Windows\System32\WINDOW~1\v1.0\;C:\PROGRA~2\COMMON~1\ROXIOS~1\DLLSHA~1\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\VSShell\Common7\IDE\;c:\PROGRA~2\MI3EDC~1\100\DTS\Binn\;C:\PROGRA~2\WIC4A1~1\Shared;C:\PROGRA~2\COMMON~1\SOFTIM~1;C:\PROGRA~1\COMMON~1\SOFTIM~1;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\samples\repl;C:\PROGRA~1\INTERN~1;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64\oci920_8
.
***************************************************
* To start WebLogic Server, use a username and *
* password assigned to an admin-level user. For *
* server administration, use the WebLogic Server *
* console at http:\\hostname:port\console *
***************************************************
starting weblogic with Java version:
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)
Starting WLS with line:
C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin\java -server -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m -Dweblogic.Name=DefaultServer -Djava.security.policy=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.policy -Doracle.jdeveloper.adrs=true -Dweblogic.nodemanager.ServiceEnabled=true -Xverify:none -Djava.endorsed.dirs=C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\lib\endorsed;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\endorsed -Djava.protocol.handler.pkgs="oracle.mds.net.protocol" -Dopss.version=12.1.3 -Digf.arisidbeans.carmlloc=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\carml -Digf.arisidstack.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\arisidprovider -Doracle.security.jps.config=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\jps-config.xml -Doracle.deployed.app.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\servers\DefaultServer\tmp\_WL_user -Doracle.deployed.app.ext=\- -Dweblogic.alternateTypesDirectory=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.ossoiap_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.oamprovider_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3 -Dweblogic.jdbc.remoteEnabled=false -Dcommon.components.home=C:\Oracle\Middleware\Oracle_Home\oracle_common -Djrf.version=12.1.3 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1 -Doracle.server.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\servers\DefaultServer -Doracle.domain.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig -Doracle.mds.filestore.preferred=true -Dadf.version=12.1.3 -da -Dwls.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Dweblogic.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Djps.app.credential.overwrite.allowed=true -Djavax.management.builder.initial=weblogic.management.jmx.mbeanserver.WLSMBeanServerBuilder -Djava.util.logging.manager=oracle.core.ojdl.logging.ODLLogManager weblogic.Server
Jul 04, 2015 12:58:37 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jul 04, 2015 12:58:50 PM oracle.security.jps.internal.idstore.util.LibOvdUtil pushLdapNamesToLibOvd
INFO: Pushed ldap name and types info to libOvd. Ldaps : DefaultAuthenticator:idstore.ldap.provideridstore.ldap.
Jul 04, 2015 12:58:57 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
2015-07-04 12:59:32.724/112.272 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational configuration from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence.xml"
2015-07-04 12:59:32.970/112.518 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational overrides from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence-override-dev.xml"
2015-07-04 12:59:33.410/112.958 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/tangosol-coherence-override.xml" is not specified
2015-07-04 12:59:33.462/113.010 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-config.xml" is not specified
2015-07-04 12:59:33.500/113.048 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-builder-config.xml" is not specified
2015-07-04 12:59:33.564/113.112 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/custom-mbeans.xml" is not specified
Oracle Coherence Version 12.1.3.0.0 Build 52031
Grid Edition: Development mode
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Jul 04, 2015 12:59:57 PM oracle.dms.servlet.DMSServletFilter setEagerlySetContextValues
INFO: The setting that controls the eager fetching of some types of execution context data has been set to true.
IntegratedWebLogicServer startup time: 514642 ms.
[IntegratedWebLogicServer started.]
[Running application MyWebNews on IntegratedWebLogicServer...]
[02:12:16 PM] Web Module ViewControllerWebApp.war recognized in project ViewController.jpr
[02:12:21 PM]
Deployment started.
[02:12:21 PM] Target platform is (Weblogic 12.x).
[02:13:10 PM] Retrieving existing application information
[02:13:11 PM] Running dependency analysis...
[02:13:11 PM] Deploying 2 profiles...
[02:13:14 PM] Wrote Web Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews\ViewControllerWebApp.war
[02:13:17 PM] Wrote Enterprise Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews
[02:13:17 PM] Deploying 1 data source(s) to the server...
[02:13:24 PM] Redeploying Application...
[02:17:31 PM] Application Redeployed Successfully.
[02:17:33 PM] The following URL context root(s) were defined and can be used as a starting point to test your application:
[02:17:33 PM] http://localhost:7101/MyWebNews-ViewController-context-root
[02:17:33 PM] http://localhost:7101/MyWebNews-ViewController-context-root
[02:17:33 PM] Elapsed time for deployment: 5 minutes, 12 seconds
[02:17:33 PM]
Deployment finished.
Run startup time: 316008 ms.
[Application MyWebNews running on IntegratedWebLogicServer]
JDeveloper JSF URL
Target URL -- http://localhost:7101/MyWebNews-ViewController-context-root/faces/jdlotusfeed.jsf
<_checkTimestamp>
Lotus Notes Data in JDeveloper Console
AlienHouse http://localhost/docucontent.nsf/xpissuesformnewuser.xsp Low Testing
username107 http://localhost/docucontent.nsf/xpusersubmit.xsp Low I need more Cow Bells
Notes Log
07/04/2015 01:12:35 PM XSP Command Manager initialized
07/04/2015 01:12:35 PM No statistics block. HTTP load statistics will not be collected
07/04/2015 01:12:35 PM HTTP Server: Started
07/04/2015 01:13:28 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:28 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 01:13:47 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:47 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:19:06 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 02:19:06 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 02:19:07 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 02:19:08 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:27:15 PM XSP Command Manager terminated
07/04/2015 02:28:19 PM HTTP Server: Shutdown
JavaAgent Properties
version: 2015.07.05.12.20.AM